/*
 Navicat Premium Data Transfer

 Source Server         : 甄宝线上
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : rm-bp15m1koq9466l58zko.mysql.rds.aliyuncs.com:3306
 Source Schema         : mall

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 19/09/2020 15:05:33
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for zb_bank
-- ----------------------------
DROP TABLE IF EXISTS `zb_bank`;
CREATE TABLE `zb_bank` (
  `bank_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `is_deleted` bit(1) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `bank_code` varchar(255) DEFAULT NULL,
  `bank_logo` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_pic` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bank_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of zb_bank
-- ----------------------------
BEGIN;
INSERT INTO `zb_bank` VALUES (1, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'ICBC', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/ICBC1.png', '中国工商银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/ICBC.png');
INSERT INTO `zb_bank` VALUES (2, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'PSBC', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/PSBC1..png', '中国邮政储蓄银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/PSBC.png');
INSERT INTO `zb_bank` VALUES (3, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'ABC', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/ABC1.png', '中国农业银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/ABC.png');
INSERT INTO `zb_bank` VALUES (4, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'CCB', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CCB1.png', '中国建设银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CCB.png');
INSERT INTO `zb_bank` VALUES (5, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'BOC', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/BOC1.png', '中国银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/BOC.png');
INSERT INTO `zb_bank` VALUES (6, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'CMBC', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CMBC1.png', '中国民生银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CMBC.png');
INSERT INTO `zb_bank` VALUES (7, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'CMB', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CMB1.png', '招商银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CMB.png');
INSERT INTO `zb_bank` VALUES (8, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'CJB', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CJB1.png', '兴业银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CJB.png');
INSERT INTO `zb_bank` VALUES (9, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'CNCB', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CNCB1.png', '中信银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CNCB.png');
INSERT INTO `zb_bank` VALUES (10, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'SDPB', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/SDPB1.png', '浦发银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/SDPB.png');
INSERT INTO `zb_bank` VALUES (11, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'CEB', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CEB1.png', '中国光大银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/CEB.png');
INSERT INTO `zb_bank` VALUES (12, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'GDB', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/GDB1.png', '广发银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/GDB.png');
INSERT INTO `zb_bank` VALUES (13, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'BOCOM', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/BOCOM1.png', '中国交通银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/BOCOM.png');
INSERT INTO `zb_bank` VALUES (14, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'PAB', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/PAB1.png', '平安银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/PAB.png');
INSERT INTO `zb_bank` VALUES (15, '2020-06-17 17:50:26', '超管', b'0', '2020-06-17 17:50:26', 'HXB', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/HXB1.png', '华夏银行', 'https://zbq-mall.oss-cn-hangzhou.aliyuncs.com/bank/images/HXB.png');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
